<%@ page import="java.sql.Connection" %>
<%@ page import="java.sql.Statement" %>
<%@ page import="java.sql.DriverManager" %>
<%@ page import="java.sql.SQLException" %><%--
  Created by IntelliJ IDEA.
  User: Administrator
  Date: 2018/3/24 0024
  Time: 下午 10:12
  To change this template use File | Settings | File Templates.
--%>
<%@ page contentType="text/html;charset=UTF-8" language="java" %>
<html>
<head>
    <title>Title</title>
</head>
<body>
<p><a href="userList.jsp">返回列表</a></p>
<%
    request.setCharacterEncoding("UTF-8");
    String id = request.getParameter("id");
    Connection connection = null;
    Statement statement = null;

    try {
        Class.forName("com.mysql.jdbc.Driver");
        connection = DriverManager.getConnection("jdbc:mysql://localhost:" +
                "3306/sctu-javaweb-2018?serverTimezone = " +
                "UTC&&characterEncoding = UTF-8", "root", "123456");
        statement = connection.createStatement();
        statement.executeUpdate("DELETE FROM t_users WHERE id = " + id + "");

    } catch (SQLException e) {
        e.printStackTrace();
    } finally {
        try {
            connection.close();
            statement.close();
        } catch (SQLException e) {
            e.printStackTrace();
        }
    }
%>
<%@ include file="footer.jsp"%>
</body>
</html>
